<div class="centerBoxWrapper" id="whatsNew">
<div class="centerBoxHeading">Customers also liked:</div>
<?php $products_id = (int)$_GET['products_id']; 
$flash_page_id_con = array();
$flash_page_images_con = array();
$flash_page_price_con = array();
$flash_page_name_con = array();
$flash_page_query = "select p.products_id,p.products_image,pd.products_name from " . TABLE_PRODUCTS ." p, ". TABLE_PRODUCTS_DESCRIPTION . " pd where p.`products_id`=pd.`products_id` AND pd.`language_id` = '" . (int)$_SESSION['languages_id'] . "' AND p.`master_categories_id` = " . zen_get_products_category_id($products_id) . " ORDER BY rand() limit 8";
$flash_page = $db->Execute($flash_page_query);
while(!$flash_page->EOF){
$flash_page_items[] = $flash_page->fields;
$flash_page_id_con[] = $flash_page->fields['products_id'];
$flash_page_images_src = is_int(strpos($flash_page->fields['products_image'],','))? substr($flash_page->fields['products_image'],0,strpos($flash_page->fields['products_image'],',')):$flash_page->fields['products_image'];
$flash_page_images_con[] = '"'.(zen_not_null($flash_page->fields['products_image']) ? $flash_page_images_src : PRODUCTS_IMAGE_NO_IMAGE ).'"';
$flash_page_price_con[] = '"'.$currencies->display_price(zen_get_products_base_price($flash_page->fields['products_id']),zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'"';
$flash_page_name_con[] = '"'.zen_output_string(zen_get_products_name($flash_page->fields['products_id'])).'"';
$flash_page->MoveNext();
}
$flash_page_id = implode(",", $flash_page_id_con);
$flash_page_images = implode(",", $flash_page_images_con);
$flash_page_price = implode(",", $flash_page_price_con);
$flash_page_name = implode(",", $flash_page_name_con);
$flash_page_display_num = $flash_page->RecordCount();

$product_price_base=trim(zen_get_products_base_price(((int)$_GET['products_id'])));

?>
<?php for($i = 0; $i< $flash_page_display_num ; $i++){?>
<?php 
$div_num="";?><div class="centerBoxContentsNew centeredContent back" style="width:25%;"><div class="plistrowcss"><div class="plistimg1"><a href="<?php echo zen_href_link(zen_get_info_page($flash_page_items[$i]['products_id']), 'products_id=' . $flash_page_items[$i]['products_id']);?>"><?php echo zen_image(DIR_WS_IMAGES . $flash_page_items[$i]['products_image'], $flash_page_items[$i]['products_name'], IMAGE_PRODUCT_NEW_WIDTH, IMAGE_PRODUCT_NEW_HEIGHT); ?></a></div><a href="<?php echo zen_href_link(zen_get_info_page($flash_page_items[$i]['products_id']), 'products_id=' . $flash_page_items[$i]['products_id']);?>"><?php echo $flash_page_items[$i]['products_name']; ?></a><div class="itemPrice "><span id="cell_price<?php echo $i?>"><?php echo zen_get_products_display_price($flash_page_items[$i]['products_id']); ?></span></div></div></div><?php if(($i+1)%4==0){ echo '<br class="clearBoth" />';}?><?php }?>
<br class="clearBoth" />
</div>